package com.example.demo.mapper;

import com.example.demo.entity.Source;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface GpaMapper {

    @Select("select stu_name,gpa from db.dashuju ORDER BY gpa desc")
    List<Source> getDashujuGpa();

    @Select("select stu_name,gpa from db.jisuanjiyingyong ORDER BY gpa desc")
    List<Source> getJisuanjiyingyongGpa();//计算机应用

    @Select("select stu_name,gpa from db.ruanjiangongcheng ORDER BY gpa desc")
    List<Source> getRuanjiangongchengGpa();//软件工程

    @Select("select stu_name,gpa from db.ruanjianjishu ORDER BY gpa desc")
    List<Source> getRuanjianjishuGpa();//软件技术

    @Select("select stu_name,gpa from db.wangluogongcheng ORDER BY gpa desc")
    List<Source> getWangluogongchengGpa();//网络工程

    @Select("select stu_name,gpa from db.wangluojishu ORDER BY gpa desc")
    List<Source> getWangluojishuGpa();//网络技术

    @Select("select stu_name,gpa from db.wulianwang ORDER BY gpa desc")
    List<Source> getWulianwangGpa();//物联网

    @Select("select stu_name,gpa from db.xinxiguanli ORDER BY gpa desc")
    List<Source> getXinxiguanliGpa();//信息管理

}
